play makAll work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All HBAM2016AUG95 Pro 3.0 All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dullCopyright 1984-1996 Claris Corporation and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. leafri0432@ bell@ STATE HBAM3016AUG95@ alfred betty carol connie corinne fenton george james karen kateX maryX kateX maureen onnie robert bogardus brustin butler carlson christopher crawford friedman george janowski jonesN jones kellerman killefer mcclendon micali monahan mozley sansbury spencer 167-0432 231-4589 433-2752 495-3023 513-0689 546-3699 569-8574 574-8656 720-0225 742-3791 839-0856 betchr8656 bilgeo3023 carbog8594 concra3791 fenjon0856 frabel0225 jamcar2752 jimkel0689 karjan3699 10/11/98 Yesf% Helvetica Geneva ADDRESS ALPHA ALPHA AREA CODE BALANCE DUE CATEGORY CONCAT NAME COUNT DUPES DUPE WARNING DUPECHECK DUPE FIRST FIRST MARK LATEST MATCH C MAX DUPE SERIAL ID MONEY MONEYSUM NOT\MAX SERIAL ID PAYMENTS PAYMENTSSUM # PHONE NUM SERIAL SERIAL AddressB CityB StateB CategoryB A Serial AlphaB Alpha A Area codeB A Phone numB Serial A0006N @$A Main View Alphabet Clairvoyance ast g Yesf% Yesf% Yesf% Yesf% FirstD LastF AddressH CityJ StateL CategoryO AlphabetQ DupeCheckU Dupe MarkV Serial Latest\ Dupe Warning] Max Dupe Serial ID_ Count Dupesa Concat Namec Moneyf Paymentsi Balance Duej Listn Clairvoyanceo Findp MoneySumq PaymentsSumt ?uUThis layout has most of the fields on it, including the DupeCheck and summary fields.th s Visibility Relationships. You can look ahead if you want. It would be good to work on a copy. I ve tried to label things pretty well. Feel free to delete all these and import your own records. Yesf% Yesf% Yesf% Yesf% Yesf% Yesf% Yesf% Yesf% Yesf% ------------- List View Scripts Find All & Sort Go Main Serial ID Go DupeCheck (ID) ------------- Alphabet Scripts Go Main Alpha g "------------- Clairvoyance Scripts Clairvoyancer Go Serial ID -Match Last g Alpha Layout List Layout ------------- General Scripts Find All Duplicates Find Later Duplicates Find Earlier Duplicates Sort All <-Sort\Ex. Sort\Export\Import Go Main Alpha g Helvetica Geneva (LIST VDEFA( Alpha FMRLA Self Alpha SRPTH alis FPTHASHard Dork:Desktop Folder: Document :FM stuff : My templates:Small files:Phone.txt MSPCA NAMEA Phone.txt RPTHA Phone.txt Hard Dork Phone.txt TEXTttxt Small files SHard Dork:Desktop Folder: Document :FM stuff : My templates:Small files:Phone.txt (LIST VDEFA( Alpha FMRLA FMRLA FMRLA stewart truesdale wright a0001 a0002 a0003 a0004 a0005 a0006 a0007 a0008 a0009 a0010 a0011 a0012 a0013 a0014 a0015 a0016 a0017 a0018 a0019 a0020 a0021 a0022 a0023 a0024 a0025 a0026 a0027 149-0607 167-0432 172-7689 231-4589 263-6806 433-2752 495-3023 513-0689 546-3699 569-8574 574-8656 596-1904 680-1687 720-0225 727-3291 742-3791 839-0856 benpau3291 betchr8656 bilgeo3023 carbog8594 concra3791 cormon1904 fenjon0856 frabel0225 halmic1687 jamcar2752 jimkel0689 karjan3699 A Main ViewB Yesf% Yesf% Yesf% Yesf% Yesf% ListB Yesf% Yesf% Yesf% Yesf% Yesf% Pro 3.0 - 4.0 I01234P FileMaker Temp ^0K (^1%) available on 1234567890 FileMaker Prefs Preferences Pro 4.0v2 FileMaker Extensions FileMaker Templates FileMaker Registration Template Information Claris December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter ListP ClairvoyanceRfClick on the radio buttons (Alpha g field) to reset the Portal. Click on a name to go to main screen. Pro 3.0F! Pro 3.0 - 4.0M1 Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 141-8594 149-0607 167-0432 172-7689 173-0357 221-0036 231-4589 263-6806 369-3326 373-3071 407-7092 433-2752 495-3023 513-0689 546-3699 569-8574 574-8656 596-1904 680-1687 720-0225 727-3291 742-3791 839-0856 alftru3071 benpau3291 betchr8656 bilgeo3023 carbog8594 concra3791 cormon1904 fenjon0856 frabel0225 geoste3326 halmic1687 jamcar2752 jimkel0689 karjan3699 stewartY Sort All <-Sort\Ex. Sort\Export\Import Clairvoyancer Self Serial g STATE AddressB CityB StateB CategoryB A Serial AlphaB Alpha A Area codeB A Phone numB Serial Counter1 Yesf% Yesf% Yesf% Portal ReplaceB Yesf% Yesf% Yesf% Yesf% Yesf% 581-0575 JimB KellermanC P.O. Box 7815D Menlo ParkE 94026G LeadH 0021I 253-7914 Yesf% Yesf% Yesf% Yesf% Yesf% X Dupe MarkY Count DupesZ First Mark[ Max ] Main^ Clairvoyance_ Alphabet` Finda Allc Serial Max Dupe Serial IDf Match cB 1) & " 2) & " " & A DupeCheckB 3) & 3) & LatestB "Latest" Latest A Dupe MarkB Max Dupe Serial IDB A+"A" & P("000" & Dupe WarningB "Duplicate") Duplicate2 Count DupesB First MarkB Yesf% Helvetica Geneva Verdana TRPTH FPTHATHard Dork:Desktop Folder: Document :FM stuff : My templates:Small files:Phone.text MSPCA NAMEA Phone.text RPTHA Phone.text FMRLA FMRLA Self AlphaB Self Serial g FranB BellC 5033 Bryant St.D Palo AltoE 94301G ClientH A0001I 720-0225U FraBel0225_ Fran Bell CarolB BogardusC 9503 N. Calif. St.D Palo AltoE 94303-3407G ClientH A0002I 141-8594U CarBog8594_ Carol Bogardus NoahB BrustinC 3511 Portola Dr.D Santa CruzE ClientH A0003I 231-4589U NoaBru4589_ Noah Brustin ButlerH A0004I 569-8574U RayBut8574_ Ray Butler JamesB CarlsonC 122 Kane Dr.D SaratogaE 95070G ClientH A0005I 433-2752U JamCar2752_ James Carlson BettyB ChristopherC 1352 Holly Ave.D Los AltosE 94024G ClientH A0006I 574-8656U BetChr8656_ Betty Christopher` BettyB ChristopherH A0007I 574-8656U BetChr8656_ Betty Christopherb BettyB ChristopherH A0008I 574-8656U BetChr8656_ Betty Christopher BettyB ChristopherH A0009I 574-8656U BetChr8656_ Betty Christopher Connie ListB This is the sample file for this month s FileMaker 101 Duplicates article. It also has the layouts for next month s article on Visibility and Relationships, including my own Clairvoyance script. You can look ahead, but you ll have to wait for the article (it s not even written). It would be best to work on a copy of this file. Otherwise feel free to delete all these and import your own phone number records. If yours don t have serial ID s, be sure to check the auto-enter box that appears leafri0432 marspe7092 marwri0357 mausan0036 noabru4589 onnkil0607 pammcc6806 raybut8574 robmoz7689 alfredZ alfred truesdaleZ betty christopherF billL georgeL bogardusB brustinC butlerD carlsonE carolB carol bogardusB christopherF connieJ connie crawfordJ corinneT corinne monahanT crawfordJ fentonN fenton jones franA bellA friedmanK georgeL george stewartY micaliR jamesE james carlsonE janowskiM kellermanO jonesN karenM karen janowskiM kateX kellermanO killeferP leahK friedmanK maryX spencerX maureenW maureen sansburyW mcclendonQ micaliR monahanT mozleyU noahC brustinC onnieP onnie killeferP mcclendonQ paulV butlerD robertU robert mozleyU sansburyW spencerX stewartY after the Import dialog, so they get some. You can also reserialize afterwards. As far I can tell, it doesn t mess up anything. Run the scripts to find Duplicates up in the Script Menu. Notice how the All Duplicates finds the original record as well, whereas the others exclude either the first or last entries. The Sort\Export\Import is in there for users of FM 3.x, who can t set portals to sort. If you have v.4, set your portals to sort (I still use v.3). It sorts then exports all record s, deletes all, then imports them again in a sorted order. It s an old, fortunately obsolete trick. This file is unlocked. Look through the Field Definitions, Relationships and Scripts, and the interaction between them. The List layout shows most of the fields that are used in Duplicates article. Next month I ll explain the Alphabet and Clairvoyance layouts. The basic function is pretty self-explanatory, so go ahead and check it out. FirstB LastB AddressB CityB StateB CategoryB A Serial A0028 AlphaB Alpha A Area codeB A Phone numB Serial Counter1 Go Serial ID -Match Last g Go Main Serial ID Go DupeCheck (ID) Find Later Duplicates Find All Duplicates ------------- List View Scripts Find Earlier Duplicates Find All & Sort Begin[ Match c_ Alphabet` Lista|Click the Begin button, add (or subtract) letters, then hit Enter. Click the name in the Portal to view person in Main View. Begin Yesf% Yesf% HelpB l free to delete all these and import your own phone number records. it for the article (it s not even written). It would be best to work on a copy of this file. Otherwise feel free to delete all these and import your own phone number records. Clairvoyancer Clairvoyancer th calcula ClairvoyanceB Yesf% Yesf% Yesf% Yesf% Yesf% CrawfordC 24450 Dartmouth St.D Palo AltoE 94306G ClientH A0010I 742-3791U ConCra3791_ Connie Crawford LeahB FriedmanC 7692 Frenchman's Rd.D StanfordE 94305G ClientH A0011I 167-0432U LeaFri0432_ Leah Friedman BillB GeorgeC 6204 Caminito De TacoD San DiegoE ClientH A0012I 495-3023U BilGeo3023_ Bill George KarenB JanowskiC 1785 EdithD Los AltosE 94022G ClientH A0013I 546-3699U KarJan3699_ Karen Janowski FentonB Jones, Sr.C 4666 Imperial St.D LargoE 34641G ClientH A0014I 839-0856U FenJon0856_ Fenton Jones, Sr. JimB KellermanC P.O. Box 769D Menlo ParkE 94026G LeadH A0015I 513-0689U JimKel0689_ Jim Kellerman OnnieB KilleferC 8556 Porter Gulch Rd.D AptosE 95003G ClientH A0016I 149-0607U OnnKil0607_ Onnie Killefer PamB McClendonC P.O. Box 7852D SoquelE 95073G ClientH A0017I 263-6806U PamMcC6806 TRPTH FPTHATHard Dork:Desktop Folder: Document :FM stuff : My templates:Small files:Phone.text MSPCA NAMEA Phone.text RPTHA Phone.text PamB McClendonC P.O. Box 773D SoquelE 95073G ClientH 0006I 263-6806U PamMcC6806_ Pam McClendon PamB McClendonC P.O. Box 773D SoquelE 95073G ClientH 0006I 263-6806U PamMcC6806_ Pam McClendon ntasC 4145 S. TropicoD La MesaE 91941G ClientH 0033I 692-8524U MarMen8524_ Mary Ann Mentas ClientH 0013I 941-1489U HalMic1489_ Hal Micali CorinneB MonahanC 1525 Alma St.D Palo AltoE 94301G ClientH 0007I 326-1713U CorMon1713_ Corinne Monahan RobertB MozleyC 601 Laurel Ave.D Menlo ParkE 94025-2608G ClientH 0008I 322-1561U RobMoz1561_ Robert Mozley CathyB Parksustin Pam McClendon MicaliC 2552 Solana Dr.D Los AltosE 94022G ClientH A0018I 680-1687U HalMic1687_ Hal Micali MicaliC 2552 Solana Dr.D Los AltosE 94022G ClientH A0019I 680-1687U HalMic1687_ Hal Micali CorinneB MonahanC 1565 Alma St.D Palo AltoE 94301G ClientH A0020I 596-1904U CorMon1904_ Corinne Monahan RobertB MozleyC 6051 Laurel Ave.D Menlo ParkE 94025-2608G ClientH A0021I 172-7689U RobMoz7689_ Robert Mozley PaulC 6552 Salvatierra St.D StanfordE 94305-2145G ClientH A0022I 727-3291U BenPau3291_ Ben Paul MaureenB SansburyC 633 Tagus Ave.D Portola ValleyE 94028G ClientH A0023I 221-0036U MauSan0036_ Maureen Sansbury A Mary KateB SpencerC 9155 Hermosa Ave.D Menlo ParkE 94025H A0024I 407-7092U MarSpe7092_ Mary Kate Spencer GeorgeB StewartC 625 KendallD Palo AltoE 94306G ClientH A0025I 369-3326U GeoSte3326_ George Stewart AlfredB TruesdaleC 7522 Hermosa St.D Menlo ParkE 94025G ClientH A0026I 373-3071U AlfTru3071_ Alfred Truesdale MariB WrightC 630 Kendall Ave.D Palo AltoE 94306G ClientH A0027I 173-0357U MarWri0357_ Mari Wright 680-1687 720-0225 727-3291 742-3791 839-0856 alftru3071 benpau3291 betchr8656 bilgeo3023 carbog8594 concra3791 cormon1904 fenjon0856 frabel0225 geoste3326 halmic1687 jamcar2752 jimkel0689 karjan3699 PamMcC6806 Yesf% Yesf% Yesf% Yesf% Yesf% Self AlphaB Self Serial gE Match Last gF Self\DupeG Self Serial g Copy Self AlphaB Self Serial gE Match Last g atch Last g FMRLA FMRLA AlphabetB Yesf% Yesf% Yesf% Yesf% Yesf% Yesf% Yesf% Yesf% bellA paulV bettyF betty christopherF billL georgeL bogardusB brustinC butlerD carlsonE carolB carol bogardusB christopherF connieJ connie crawfordJ corinneT corinne monahanT crawfordJ fentonN fenton jones franA bellA friedmanK georgeL george stewartY micaliR jamesE james carlsonE janowskiM kellermanO jonesN karenM karen janowskiM kateX kellermanO killeferP leahK friedmanK mari[ wright[ maryX spencerX maureenW maureen sansburyW mcclendonQ micaliR monahanT mozleyU noahC brustinC onnieP onnie killeferP mcclendonQ paulV butlerD robertU robert mozleyU sansburyW spencerX stewartY truesdaleZ wright[ bel0225 halmic1687 jamcar2752 jimkel0689 karjan3699 Not\Max Serial IDB Concat NameB & " " & MoneyB MoneySumB PaymentsB PaymentsSumB Balance DueB @@@@@@ Alpha Layout List Layout ------------- Alphabet Scripts A"------------- Clairvoyance Scripts ------------- General Scripts sansbury spencer carol bogardus brustin butler james carlson betty christopher connie crawford friedman george karen janowski fenton jones kellerman onnie killefer mcclendon micali corinne monahan robert mozley maureen sansbury spencer george stewart alfred truesdale wright wright